	(C) Copyright 1991-1993 by Alan J. Avery.  All Rights Reserved.

	Sample command file for SDF.EXE, the program that lets the user convert
	delimited ASCII files without programming and without using a spreadsheet,
	database, word processor or other major application program.
	The basic format of this file is simple:
   
	Start comments with a space, tab, asterisk or semicolon in column 1.

	Blank lines will be ignored, as will anything that is not recognized
	to be a command.

	Commands MUST start in column 1 (!) and can be in UPPER or lower case.
	If a command requires a value associated with it, this value must
	begin in column 21 or later!
	Some commands pertain to processing the entire file, others pertain to
	processing a particular field.  File commands are listed first in this
	sample command file, field commands follow.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				ONLY
				ÍÍÍÍ
	Forces the fields specified below to be kept in the file that is
	created, and no others.

Only
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				REORDER
				ÍÍÍÍÍÍÍ
	Forces the fields to be kept in the order encountered in this file.
	Note! If you use REORDER, then ONLY is assumed as well.

Reorder
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				INPUT FILE
				ÍÍÍÍÍÍÍÍÍÍ
	Specifies the name of the file to be processed.
	Note! This can be overridden at processing time with the command-line
	      switch /I=<filename>

Input File		  FILE1.PRN
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				OUTPUT FILE
				ÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the name of the file to be created.  The extension is ignored
	for PARADOX files.
	Note! This can be overridden at processing time with the command-line
	      switch /O=<filename>

Output File		 FILE2.DBF
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELDS PER LINE
				ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the maximum # of fields to expect per line.  Keep this
	number as small as possible.  The default is 500.

Fields Per Line	 400
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				
				SURROUNDED BY
				ÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the character that optionally surrounds fields in a file
	whose input format is DEL.

Surrounded By	   "
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				DELIMITED BY
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the character that optionally delimits fields in a file
	whose input format is DEL.

Delimited By		,
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FILL WITH
				ÍÍÍÍÍÍÍÍÍ
	Specifies the character used to fill unused space in the output file.
	Denote it by putting the character used to indicate it in column 21, if
	is is not a control character (less than ASCII 32).
	This can also be denoted by entering an ASCII number from 0 to 255,
	starting in column 21.  The default is 32, the [Space] character.
	For example, 9 would be a [Tab] character.

Fill With		   32
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				LINE START
				ÍÍÍÍÍÍÍÍÍÍ
	Specifies the line number at which processing is to start.

Line Start		  1
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				LINE END
				ÍÍÍÍÍÍÍÍ
	Specifies the line number at which processing is to end.  Use with LINE
	START (see above) to denote a range of lines to process.

Line End			200
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				MAXIMUM LENGTH
				ÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the maximum length for any field in the output file.

Maximum Length
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				MINIMUM LENGTH
				ÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the minimum length for any field in the output file.

Minimum Length
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				OMIT IF EMPTY
				ÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Forces empty fields to be omitted from the output file.

Omit If Empty
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				INPUT FORMAT
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the type of input file to be processed.  Only two choices are
	available:
		SDF (for System Data Format file)
		DEL (for a delimited file)

Input Format	   SDF
Input Format	   DEL
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				OUTPUT FORMAT
				ÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the type of output file to create.  The choices available are:
		SDF (the default, for System Data Format),
		DEL (for delimited)
		DB3 (for dBase III type)
		PDX35 (for Paradox 3.5)
		PDX40 (for Paradox 4.0)
		PDX   (for Paradox 4.0)

Output Format	   SDF
Output Format	   DB3
Output Format	   DEL
Output Format	   PDX35
Output Format	   PDX40
Output Format	   PDX		(same as PDX40)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				SURROUND WITH
				ÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the character to be used to surround the fields in the output
	file.  This is only used if DEL is the output format.

Surround With	   "
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				DELIMIT WITH
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies the character to be used to delimit the fields in the output
	file.  This is only used if DEL is the output format.

Delimit With		,			(a comma)

	Note: Use the \## form of the parameter to specify an ASCII character.
		  Here, the symbol \32 signifies a [Space].
Delimit With		\32
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				VARIABLE LENGTH
				ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifies that the INPUT file cannot be assumed to have the same length
	for each line in the file.
	This is only needed for SDF input files, which usually have identical
	lengths per record.

Variable Length
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				TRIM SPACES
				ÍÍÍÍÍÍÍÍÍÍÍ
	Specifies that trailing fill characters (usually spaces, but specified
	with the FILL WITH command mentioned earlier) in each OUTPUT record
	should be removed before the record is written to disk.
	This is only needed for SDF output files, which usually have identical
	lengths per record.

Trim Spaces
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

	Field commands follow.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELD NUMBER
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Denotes the index of the field in the input file that the following
	commands will pertain to.  It MUST precede any field commands that
	are used.

Field Number		1
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELD START
				ÍÍÍÍÍÍÍÍÍÍÍ
	Denotes the character position to start reading data from in this field.
	In the example below, no characters are skipped (the default).

Field Start		 1
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELD LENGTH
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Denotes the number of characters of this field to put in the output file.

Field Length		20
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELD NAME
				ÍÍÍÍÍÍÍÍÍÍ
	If the Output Format command is DB3, PDX35, PDX40 or PDX, this gives
	the field a name.

Field Name		  Text
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELD OFFSET
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	If the Input Format command is SDF, this specifies where the data for
	this field begins in the input file.

Field Offset		15
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				FIELD TYPE
				ÍÍÍÍÍÍÍÍÍÍ
	If the Output Format is DB3, this specifies a field type.  If the Output
	Format is PDX35 or PDX40 or PDX, this specifies a Paradox field type.
	Only Alphanumeric field types are supported.

Field Type		  C	(for DB3)
Field Type		  A15	(for PDX, this specifies alphanumeric of length 15)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				SEARCH FOR
				ÍÍÍÍÍÍÍÍÍÍ
	Specifies text to look for in this field.
	Note: A field can have multiple SEARCH FOR commands.

Search For		  Text
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				RESPECT CASE
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Tells program to be sensitive to upper/lowercase when searching for text.
   The default is Y or T (case is respected).  Use N or F to ignore case.

Respect Case		Y
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				MUST HAVE
				ÍÍÍÍÍÍÍÍÍ
	If Y or T, any records that do NOT have the desired text will not be
	put into the output file.

Must Have		   N
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				MUST NOT HAVE
				ÍÍÍÍÍÍÍÍÍÍÍÍÍ
	If Y or T, any records that DO have the desired text will not be put
	into the output file.

Must Not Have	   N
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				REPLACE WITH
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	If the text sought is found, it will be replaced with the text specified
	in this command.
	Note: A field can have multiple SEARCH FOR & REPLACE WITH pairs.

Replace With		Text
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				INIT WITH
				ÍÍÍÍÍÍÍÍÍ
	Specifies text used to initialize field prior to working on it.

Init With		   Text
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				CONVERT TEXT
				ÍÍÍÍÍÍÍÍÍÍÍÍ
	Specifes that the text in the field is to be converted to UPPER, lower
	or Proper case.

Convert Text		Upper
				   THIS IS PROPER CASE. (All letters capitalized)
Convert Text		Lower
				   this is lower case. (no letters capitalized)
Convert Text		Proper
				   This Is Proper Case. (First letter capitalized)
	Note: 'Convert Text' is executed prior to any 'Search For' (and 
		  'Replace With') commands.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				JUSTIFY
				ÍÍÍÍÍÍÍ
	Forces text in a field to be aligned to the extreme left or extreme right.
	For example, '   123' would be left-justified to '123   ', and '123   '
	would be right-justified to '   123'.

Justify			 Right
Justify			 Left
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				TRIM FRONT
				ÍÍÍÍÍÍÍÍÍÍ
	Specifies the number of characters to trim from the front of a field
	after it's been completely processed.  This also reduces the length a
	field receives.

Trim Front		  10
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				TRIM BACK
				ÍÍÍÍÍÍÍÍÍ
	Specifies the number of characters to trim from the end of a field
	after it's been completely processed.  This also reduces the length a
	field receives.

Trim Back		  10
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				ZERO FILL
				ÍÍÍÍÍÍÍÍÍ
	Forces leading FILL characters to be changed to numeral ZEROES.
	For example, '   123' would change to '000123'.

Zero Fill
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
				ZERO UNFILL
				ÍÍÍÍÍÍÍÍÍÍÍ
	ZERO UNFILL - Converts leading ZEROES to FILL character.
	For example, '000123' would change to '   123'.

Zero Unfill
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
	The above commands only apply to ONE field.  For each additional field,
	specify the required 'Field Number' command, followed by the commands
	you want applied to the field.

	INDEX - This command can be used only when OUTPUT FORMAT specifies a
			PARADOX 3.5 or PARADOX 4.0 database.  When it is used in each of
			the first few fields, a PRIMARY index is set up.  If one or more
			fields have been defined since the last INDEX command was
			encountered, a SECONDARY index (automatically maintained by
			PARADOX) is set up.

Index

	SECONDARY INDEX - Use this to have SDF set up a secondary index on the
			current field (automatically maintained by Paradox) when it
			creates the PARADOX database.

Secondary Index
